<!doctype html>



  


<html class="theme-next pisces use-motion">
<head>
  <meta charset="UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"/>



<meta http-equiv="Cache-Control" content="no-transform" />
<meta http-equiv="Cache-Control" content="no-siteapp" />












  
  
  <link href="/vendors/fancybox/source/jquery.fancybox.css?v=2.1.5" rel="stylesheet" type="text/css" />




  
  
  
  

  
    
    
  

  

  

  

  

  
    
    
    <link href="//fonts.googleapis.com/css?family=Lato:300,300italic,400,400italic,700,700italic&subset=latin,latin-ext" rel="stylesheet" type="text/css">
  






<link href="/vendors/font-awesome/css/font-awesome.min.css?v=4.4.0" rel="stylesheet" type="text/css" />

<link href="/css/main.css?v=5.0.1" rel="stylesheet" type="text/css" />


  <meta name="keywords" content="php,后端,mysql," />








  <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico?v=5.0.1" />






<meta name="description" content="不废话，直接上代码

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989">
<meta property="og:type" content="article">
<meta property="og:title" content="php mysql数据字典工具">
<meta property="og:url" content="http://blog.caocode.com/2016/08/16/php-mysql-data/index.html">
<meta property="og:site_name" content="项羽大大的博客">
<meta property="og:description" content="不废话，直接上代码

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989">
<meta property="og:updated_time" content="2016-08-19T09:22:53.000Z">
<meta name="twitter:card" content="summary">
<meta name="twitter:title" content="php mysql数据字典工具">
<meta name="twitter:description" content="不废话，直接上代码

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989">



<script type="text/javascript" id="hexo.configuration">
  var NexT = window.NexT || {};
  var CONFIG = {
    scheme: 'Pisces',
    sidebar: {"position":"left","display":"post"},
    fancybox: true,
    motion: true,
    duoshuo: {
      userId: 0,
      author: '博主'
    }
  };
</script>




  <link rel="canonical" href="http://blog.caocode.com/2016/08/16/php-mysql-data/"/>

  <title> php mysql数据字典工具 | 项羽大大的博客 </title>
</head>

<body itemscope itemtype="http://schema.org/WebPage" lang="zh-Hans">

  



  <script type="text/javascript">
    var _hmt = _hmt || [];
    (function() {
      var hm = document.createElement("script");
      hm.src = "//hm.baidu.com/hm.js?65de5000df47cefa2d258fc5c482a218";
      var s = document.getElementsByTagName("script")[0];
      s.parentNode.insertBefore(hm, s);
    })();
  </script>








  
  
    
  

  <div class="container one-collumn sidebar-position-left page-post-detail ">
    <div class="headband"></div>

    <header id="header" class="header" itemscope itemtype="http://schema.org/WPHeader">
      <div class="header-inner"><div class="site-meta ">
  

  <div class="custom-logo-site-title">
    <a href="/"  class="brand" rel="start">
      <span class="logo-line-before"><i></i></span>
      <span class="site-title">项羽大大的博客</span>
      <span class="logo-line-after"><i></i></span>
    </a>
  </div>
  <p class="site-subtitle">一个逗比的Blog</p>
</div>

<div class="site-nav-toggle">
  <button>
    <span class="btn-bar"></span>
    <span class="btn-bar"></span>
    <span class="btn-bar"></span>
  </button>
</div>

<nav class="site-nav">
  

  
    <ul id="menu" class="menu">
      
        
        <li class="menu-item menu-item-home">
          <a href="/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-home"></i> <br />
            
            首页
          </a>
        </li>
      
        
        <li class="menu-item menu-item-archives">
          <a href="/archives" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-archive"></i> <br />
            
            归档
          </a>
        </li>
      
        
        <li class="menu-item menu-item-tags">
          <a href="/tags" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-tags"></i> <br />
            
            标签
          </a>
        </li>
      

      
    </ul>
  

  
</nav>

 </div>
    </header>

    <main id="main" class="main">
      <div class="main-inner">
        <div class="content-wrap">
          <div id="content" class="content">
            

  <div id="posts" class="posts-expand">
    

  
  

  
  
  

  <article class="post post-type-normal " itemscope itemtype="http://schema.org/Article">

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">
            
            
              
                php mysql数据字典工具
              
            
          </h1>
        

        <div class="post-meta">
          <span class="post-time">
            <span class="post-meta-item-icon">
              <i class="fa fa-calendar-o"></i>
            </span>
            <span class="post-meta-item-text">发表于</span>
            <time itemprop="dateCreated" datetime="2016-08-16T19:38:39+08:00" content="2016-08-16">
              2016-08-16
            </time>
          </span>

          

          
            
              <span class="post-comments-count">
                &nbsp; | &nbsp;
                <a href="/2016/08/16/php-mysql-data/#comments" itemprop="discussionUrl">
                  <span class="post-comments-count ds-thread-count" data-thread-key="2016/08/16/php-mysql-data/" itemprop="commentsCount"></span>
                </a>
              </span>
            
          

          

          
          

          
        </div>
      </header>
    


    <div class="post-body" itemprop="articleBody">

      
      

      
        <blockquote>
<p>不废话，直接上代码</p>
</blockquote>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br><span class="line">28</span><br><span class="line">29</span><br><span class="line">30</span><br><span class="line">31</span><br><span class="line">32</span><br><span class="line">33</span><br><span class="line">34</span><br><span class="line">35</span><br><span class="line">36</span><br><span class="line">37</span><br><span class="line">38</span><br><span class="line">39</span><br><span class="line">40</span><br><span class="line">41</span><br><span class="line">42</span><br><span class="line">43</span><br><span class="line">44</span><br><span class="line">45</span><br><span class="line">46</span><br><span class="line">47</span><br><span class="line">48</span><br><span class="line">49</span><br><span class="line">50</span><br><span class="line">51</span><br><span class="line">52</span><br><span class="line">53</span><br><span class="line">54</span><br><span class="line">55</span><br><span class="line">56</span><br><span class="line">57</span><br><span class="line">58</span><br><span class="line">59</span><br><span class="line">60</span><br><span class="line">61</span><br><span class="line">62</span><br><span class="line">63</span><br><span class="line">64</span><br><span class="line">65</span><br><span class="line">66</span><br><span class="line">67</span><br><span class="line">68</span><br><span class="line">69</span><br><span class="line">70</span><br><span class="line">71</span><br><span class="line">72</span><br><span class="line">73</span><br><span class="line">74</span><br><span class="line">75</span><br><span class="line">76</span><br><span class="line">77</span><br><span class="line">78</span><br><span class="line">79</span><br><span class="line">80</span><br><span class="line">81</span><br><span class="line">82</span><br><span class="line">83</span><br><span class="line">84</span><br><span class="line">85</span><br><span class="line">86</span><br><span class="line">87</span><br><span class="line">88</span><br><span class="line">89</span><br><span class="line">90</span><br><span class="line">91</span><br><span class="line">92</span><br><span class="line">93</span><br><span class="line">94</span><br><span class="line">95</span><br><span class="line">96</span><br><span class="line">97</span><br><span class="line">98</span><br><span class="line">99</span><br><span class="line">100</span><br><span class="line">101</span><br><span class="line">102</span><br><span class="line">103</span><br><span class="line">104</span><br><span class="line">105</span><br><span class="line">106</span><br><span class="line">107</span><br><span class="line">108</span><br><span class="line">109</span><br><span class="line">110</span><br><span class="line">111</span><br><span class="line">112</span><br><span class="line">113</span><br><span class="line">114</span><br><span class="line">115</span><br><span class="line">116</span><br><span class="line">117</span><br><span class="line">118</span><br><span class="line">119</span><br><span class="line">120</span><br><span class="line">121</span><br><span class="line">122</span><br><span class="line">123</span><br><span class="line">124</span><br><span class="line">125</span><br><span class="line">126</span><br><span class="line">127</span><br><span class="line">128</span><br><span class="line">129</span><br><span class="line">130</span><br><span class="line">131</span><br><span class="line">132</span><br></pre></td><td class="code"><pre><span class="line">&lt;?php</span><br><span class="line">/**</span><br><span class="line"> * 生成mysql数据字典</span><br><span class="line"> */</span><br><span class="line">header(&quot;Content-type: text/html; charset=utf-8&quot;);</span><br><span class="line">//配置数据库</span><br><span class="line">$dbserver   = &quot;localhost&quot;;</span><br><span class="line">$dbusername = &quot;dbUserName&quot;;</span><br><span class="line">$dbpassword = &quot;dbPWD&quot;;</span><br><span class="line">$database   = &quot;dbName&quot;;</span><br><span class="line"></span><br><span class="line">//其他配置</span><br><span class="line">$mysql_conn = @mysql_connect(&quot;$dbserver&quot;, &quot;$dbusername&quot;, &quot;$dbpassword&quot;) or die(&quot;Mysql connect is error.&quot;);</span><br><span class="line">mysql_select_db($database, $mysql_conn);</span><br><span class="line">mysql_query(&apos;SET NAMES utf8&apos;, $mysql_conn);</span><br><span class="line">$table_result = mysql_query(&apos;show tables&apos;, $mysql_conn);</span><br><span class="line"></span><br><span class="line">$no_show_table = array();    //不需要显示的表</span><br><span class="line">$no_show_field = array();   //不需要显示的字段</span><br><span class="line"></span><br><span class="line">//取得所有的表名</span><br><span class="line">while($row = mysql_fetch_array($table_result))&#123;</span><br><span class="line">	if(!in_array($row[0],$no_show_table))&#123;</span><br><span class="line">		$tables[][&apos;TABLE_NAME&apos;] = $row[0];</span><br><span class="line">	&#125;</span><br><span class="line">&#125;</span><br><span class="line">//替换所以表的表前缀</span><br><span class="line">if(@$_GET[&apos;prefix&apos;])&#123;</span><br><span class="line">	die;</span><br><span class="line">	$prefix = &apos;czzj&apos;;</span><br><span class="line">	foreach($tables as $key =&gt; $val)&#123;</span><br><span class="line">		$tableName = $val[&apos;TABLE_NAME&apos;];</span><br><span class="line">		$string = explode(&apos;_&apos;,$tableName);</span><br><span class="line">		if($string[0] != $prefix)&#123;  </span><br><span class="line">			$string[0] = $prefix;  </span><br><span class="line">			$newTableName = implode(&apos;_&apos;, $string);  </span><br><span class="line">			mysql_query(&apos;rename table &apos;.$tableName.&apos; TO &apos;.$newTableName);  </span><br><span class="line">		&#125;</span><br><span class="line">	&#125;</span><br><span class="line">	echo &quot;替换成功！&quot;;exit();</span><br><span class="line">&#125;</span><br><span class="line"></span><br><span class="line">//循环取得所有表的备注及表中列消息</span><br><span class="line">foreach ($tables as $k=&gt;$v) &#123;</span><br><span class="line">    $sql  = &apos;SELECT * FROM &apos;;</span><br><span class="line">    $sql .= &apos;INFORMATION_SCHEMA.TABLES &apos;;</span><br><span class="line">    $sql .= &apos;WHERE &apos;;</span><br><span class="line">    $sql .= &quot;table_name = &apos;&#123;$v[&apos;TABLE_NAME&apos;]&#125;&apos;  AND table_schema = &apos;&#123;$database&#125;&apos;&quot;;</span><br><span class="line">    $table_result = mysql_query($sql, $mysql_conn);</span><br><span class="line">    while ($t = mysql_fetch_array($table_result) ) &#123;</span><br><span class="line">        $tables[$k][&apos;TABLE_COMMENT&apos;] = $t[&apos;TABLE_COMMENT&apos;];</span><br><span class="line">    &#125;</span><br><span class="line"></span><br><span class="line">    $sql  = &apos;SELECT * FROM &apos;;</span><br><span class="line">    $sql .= &apos;INFORMATION_SCHEMA.COLUMNS &apos;;</span><br><span class="line">    $sql .= &apos;WHERE &apos;;</span><br><span class="line">    $sql .= &quot;table_name = &apos;&#123;$v[&apos;TABLE_NAME&apos;]&#125;&apos; AND table_schema = &apos;&#123;$database&#125;&apos;&quot;;</span><br><span class="line"></span><br><span class="line">    $fields = array();</span><br><span class="line">    $field_result = mysql_query($sql, $mysql_conn);</span><br><span class="line">    while ($t = mysql_fetch_array($field_result) ) &#123;</span><br><span class="line">        $fields[] = $t;</span><br><span class="line">    &#125;</span><br><span class="line">    $tables[$k][&apos;COLUMN&apos;] = $fields;</span><br><span class="line">&#125;</span><br><span class="line">mysql_close($mysql_conn);</span><br><span class="line"></span><br><span class="line"></span><br><span class="line">$html = &apos;&apos;;</span><br><span class="line">//循环所有表</span><br><span class="line">foreach ($tables as $k=&gt;$v) &#123;</span><br><span class="line">    $html .= &apos;	&lt;h3&gt;&apos; . ($k + 1) . &apos;、&apos; . $v[&apos;TABLE_COMMENT&apos;] .&apos;  （&apos;. $v[&apos;TABLE_NAME&apos;]. &apos;）&lt;/h3&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">    $html .= &apos;	&lt;table border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;100%&quot;&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">    $html .= &apos;		&lt;tbody&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;			&lt;tr&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;				&lt;th&gt;字段名&lt;/th&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;				&lt;th&gt;数据类型&lt;/th&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;				&lt;th&gt;默认值&lt;/th&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;				&lt;th&gt;允许非空&lt;/th&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;				&lt;th&gt;自动递增&lt;/th&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;				&lt;th&gt;备注&lt;/th&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;			&lt;/tr&gt;&apos;.&quot;\n&quot;;</span><br><span class="line"></span><br><span class="line">    foreach ($v[&apos;COLUMN&apos;] as $f) &#123;</span><br><span class="line">		if(@!is_array($no_show_field[$v[&apos;TABLE_NAME&apos;]]))&#123;</span><br><span class="line">			$no_show_field[$v[&apos;TABLE_NAME&apos;]] = array();</span><br><span class="line">		&#125;</span><br><span class="line">		if(!in_array($f[&apos;COLUMN_NAME&apos;],$no_show_field[$v[&apos;TABLE_NAME&apos;]]))&#123;</span><br><span class="line">			$html .= &apos;			&lt;tr&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">			$html .= &apos;				&lt;td class=&quot;c1&quot;&gt;&apos; . $f[&apos;COLUMN_NAME&apos;] . &apos;&lt;/td&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">			$html .= &apos;				&lt;td class=&quot;c2&quot;&gt;&apos; . $f[&apos;COLUMN_TYPE&apos;] . &apos;&lt;/td&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">			$html .= &apos;				&lt;td class=&quot;c3&quot;&gt;&apos; . $f[&apos;COLUMN_DEFAULT&apos;] . &apos;&lt;/td&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">			$html .= &apos;				&lt;td class=&quot;c4&quot;&gt;&apos; . $f[&apos;IS_NULLABLE&apos;] . &apos;&lt;/td&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">			$html .= &apos;				&lt;td class=&quot;c5&quot;&gt;&apos; . ($f[&apos;EXTRA&apos;]==&apos;auto_increment&apos;?&apos;是&apos;:&apos;&amp;nbsp;&apos;) . &apos;&lt;/td&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">			$html .= &apos;				&lt;td class=&quot;c6&quot;&gt;&apos; . $f[&apos;COLUMN_COMMENT&apos;] . &apos;&lt;/td&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">			$html .= &apos;			&lt;/tr&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">		&#125;</span><br><span class="line">    &#125;</span><br><span class="line">    $html .= &apos;		&lt;/tbody&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">	$html .= &apos;	&lt;/table&gt;&apos;.&quot;\n&quot;;</span><br><span class="line">&#125;</span><br><span class="line">?&gt;</span><br><span class="line">&lt;!doctype html&gt;</span><br><span class="line">&lt;html&gt;</span><br><span class="line">&lt;head&gt;</span><br><span class="line">&lt;meta charset=&quot;utf-8&quot;&gt;</span><br><span class="line">&lt;title&gt;数据库数据字典生成代码&lt;/title&gt;</span><br><span class="line">&lt;meta name=&quot;generator&quot; content=&quot;ThinkDb V1.0&quot; /&gt;</span><br><span class="line">&lt;meta name=&quot;author&quot; content=&quot;南昌腾速科技有限公司http://www.tensent.cn&quot; /&gt;</span><br><span class="line">&lt;meta name=&quot;copyright&quot; content=&quot;2008-2014 Tensent Inc.&quot; /&gt;</span><br><span class="line">&lt;style&gt;</span><br><span class="line">body, td, th &#123; font-family: &quot;微软雅黑&quot;; font-size: 14px; &#125;</span><br><span class="line">.warp&#123;margin:auto; width:900px;&#125;</span><br><span class="line">.warp h3&#123;margin:0px; padding:0px; line-height:30px; margin-top:10px;&#125;</span><br><span class="line">table &#123; border-collapse: collapse; border: 1px solid #CCC; background: #efefef; &#125;</span><br><span class="line">table th &#123; text-align: left; font-weight: bold; height: 26px; line-height: 26px; font-size: 14px; text-align:center; border: 1px solid #CCC; padding:5px;&#125;</span><br><span class="line">table td &#123; height: 20px; font-size: 14px; border: 1px solid #CCC; background-color: #fff; padding:5px;&#125;</span><br><span class="line">.c1 &#123; width: 120px; &#125;</span><br><span class="line">.c2 &#123; width: 120px; &#125;</span><br><span class="line">.c3 &#123; width: 150px; &#125;</span><br><span class="line">.c4 &#123; width: 80px; text-align:center;&#125;</span><br><span class="line">.c5 &#123; width: 80px; text-align:center;&#125;</span><br><span class="line">.c6 &#123; width: 270px; &#125;</span><br><span class="line">&lt;/style&gt;</span><br><span class="line">&lt;/head&gt;</span><br><span class="line">&lt;body&gt;</span><br><span class="line">&lt;div class=&quot;warp&quot;&gt;</span><br><span class="line">	&lt;h1 style=&quot;text-align:center;&quot;&gt;数据库数据字典生成代码&lt;/h1&gt;</span><br><span class="line">&lt;?php echo $html; ?&gt;</span><br><span class="line">&lt;/div&gt;</span><br><span class="line">&lt;/body&gt;</span><br><span class="line">&lt;/html&gt;</span><br></pre></td></tr></table></figure>
      
    </div>

    <div>
      
        

      
    </div>

    <div>
      
        

      
    </div>

    <footer class="post-footer">
      
        <div class="post-tags">
          
            <a href="/tags/php/" rel="tag">#php</a>
          
            <a href="/tags/后端/" rel="tag">#后端</a>
          
            <a href="/tags/mysql/" rel="tag">#mysql</a>
          
        </div>
      

      
        <div class="post-nav">
          <div class="post-nav-next post-nav-item">
            
              <a href="/2016/06/16/php-cURL-does-not-see-hosts/" rel="next" title="php cURL跳过了本地的hosts">
                <i class="fa fa-chevron-left"></i> php cURL跳过了本地的hosts
              </a>
            
          </div>

          <div class="post-nav-prev post-nav-item">
            
              <a href="/2016/08/19/php-bug/" rel="prev" title="小记php的坑(一)">
                小记php的坑(一) <i class="fa fa-chevron-right"></i>
              </a>
            
          </div>
        </div>
      

      
      
    </footer>
  </article>



    <div class="post-spread">
      
    </div>
  </div>


          </div>
          


          
  <div class="comments" id="comments">
    
      <div class="ds-thread" data-thread-key="2016/08/16/php-mysql-data/"
           data-title="php mysql数据字典工具" data-url="http://blog.caocode.com/2016/08/16/php-mysql-data/">
      </div>
    
  </div>


        </div>
        
          
  
  <div class="sidebar-toggle">
    <div class="sidebar-toggle-line-wrap">
      <span class="sidebar-toggle-line sidebar-toggle-line-first"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-middle"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-last"></span>
    </div>
  </div>

  <aside id="sidebar" class="sidebar">
    <div class="sidebar-inner">

      

      
        <ul class="sidebar-nav motion-element">
          <li class="sidebar-nav-toc sidebar-nav-active" data-target="post-toc-wrap" >
            文章目录
          </li>
          <li class="sidebar-nav-overview" data-target="site-overview">
            站点概览
          </li>
        </ul>
      

      <section class="site-overview sidebar-panel ">
        <div class="site-author motion-element" itemprop="author" itemscope itemtype="http://schema.org/Person">
          <img class="site-author-image" itemprop="image"
               src="http://7xnghc.com1.z0.glb.clouddn.com/logo.jpg"
               alt="项羽大大" />
          <p class="site-author-name" itemprop="name">项羽大大</p>
          <p class="site-description motion-element" itemprop="description">敲敲代码看看电视刷刷微博</p>

        </div>
        <nav class="site-state motion-element">
          <div class="site-state-item site-state-posts">
            <a href="/archives">
              <span class="site-state-item-count">9</span>
              <span class="site-state-item-name">日志</span>
            </a>
          </div>

          

          
            <div class="site-state-item site-state-tags">
              <a href="/tags">
                <span class="site-state-item-count">8</span>
                <span class="site-state-item-name">标签</span>
              </a>
            </div>
          

        </nav>

        

        <div class="links-of-author motion-element">
          
            
              <span class="links-of-author-item">
                <a href="https://github.com/fengci" target="_blank" title="GitHub">
                  
                    <i class="fa fa-fw fa-github"></i>
                  
                  GitHub
                </a>
              </span>
            
              <span class="links-of-author-item">
                <a href="http://weibo.com/1924817755" target="_blank" title="Weibo">
                  
                    <i class="fa fa-fw fa-weibo"></i>
                  
                  Weibo
                </a>
              </span>
            
          
        </div>

        
        

        
        
          <div class="links-of-blogroll motion-element links-of-blogroll-inline">
            <div class="links-of-blogroll-title">
              <i class="fa  fa-fw fa-globe"></i>
              友情链接
            </div>
            <ul class="links-of-blogroll-list">
              
                <li class="links-of-blogroll-item">
                  <a href="http://www.mrwood.xyz/" title="KIWI的小屋" target="_blank">KIWI的小屋</a>
                </li>
              
                <li class="links-of-blogroll-item">
                  <a href="https://xpal7512.github.io/" title="方寸随心" target="_blank">方寸随心</a>
                </li>
              
            </ul>
          </div>
        

      </section>

      
        <section class="post-toc-wrap motion-element sidebar-panel sidebar-panel-active">
          <div class="post-toc">
            
              
            
            
              <p class="post-toc-empty">此文章未包含目录</p>
            
          </div>
        </section>
      

    </div>
  </aside>


        
      </div>
    </main>

    <footer id="footer" class="footer">
      <div class="footer-inner">
        <div class="copyright" >
  
  &copy;  2015 - 
  <span itemprop="copyrightYear">2016</span>
  <span class="with-love">
    <i class="fa fa-heart"></i>
  </span>
  <span class="author" itemprop="copyrightHolder">项羽大大</span>
</div>

<div class="powered-by">
  由 <a class="theme-link" href="https://hexo.io">Hexo</a> 强力驱动
</div>

<div class="theme-info">
  主题 -
  <a class="theme-link" href="https://github.com/iissnan/hexo-theme-next">
    NexT.Pisces
  </a>
</div>

        

        
      </div>
    </footer>

    <div class="back-to-top">
      <i class="fa fa-arrow-up"></i>
    </div>
  </div>

  

<script type="text/javascript">
  if (Object.prototype.toString.call(window.Promise) !== '[object Function]') {
    window.Promise = null;
  }
</script>









  



  
  <script type="text/javascript" src="/vendors/jquery/index.js?v=2.1.3"></script>

  
  <script type="text/javascript" src="/vendors/fastclick/lib/fastclick.min.js?v=1.0.6"></script>

  
  <script type="text/javascript" src="/vendors/jquery_lazyload/jquery.lazyload.js?v=1.9.7"></script>

  
  <script type="text/javascript" src="/vendors/velocity/velocity.min.js?v=1.2.1"></script>

  
  <script type="text/javascript" src="/vendors/velocity/velocity.ui.min.js?v=1.2.1"></script>

  
  <script type="text/javascript" src="/vendors/fancybox/source/jquery.fancybox.pack.js?v=2.1.5"></script>


  


  <script type="text/javascript" src="/js/src/utils.js?v=5.0.1"></script>

  <script type="text/javascript" src="/js/src/motion.js?v=5.0.1"></script>



  
  


  <script type="text/javascript" src="/js/src/affix.js?v=5.0.1"></script>

  <script type="text/javascript" src="/js/src/schemes/pisces.js?v=5.0.1"></script>



  
  <script type="text/javascript" src="/js/src/scrollspy.js?v=5.0.1"></script>
<script type="text/javascript" src="/js/src/post-details.js?v=5.0.1"></script>



  


  <script type="text/javascript" src="/js/src/bootstrap.js?v=5.0.1"></script>



  

  
    
  

  <script type="text/javascript">
    var duoshuoQuery = {short_name:"fengci"};
    (function() {
      var ds = document.createElement('script');
      ds.type = 'text/javascript';ds.async = true;
      ds.id = 'duoshuo-script';
      ds.src = (document.location.protocol == 'https:' ? 'https:' : 'http:') + '//static.duoshuo.com/embed.js';
      ds.charset = 'UTF-8';
      (document.getElementsByTagName('head')[0]
      || document.getElementsByTagName('body')[0]).appendChild(ds);
    })();
  </script>

  
    
    <script src="/vendors/ua-parser-js/dist/ua-parser.min.js?v=0.7.9"></script>
    <script src="/js/src/hook-duoshuo.js"></script>
  






  
  

  

  

  

</body>
</html>
